prepare("select * from order_main where booking_id = '$id'") ;
$getd->execute() ;
$rwd = $getd->fetch(pdo::FETCH_ASSOC) ;
$tid = $rwd['trans_id'] ;
//get tsum
$gsum = $DBcon->prepare("select sum(total_cost) as tcost from order_details where trans_id = '$tid'") ;
$gsum->execute() ;
$grow = $gsum->fetch(pdo::FETCH_ASSOC) ;
$tsum = $grow['tcost'] ;
if(isset($_POST['search']))
{
//$date1 = trim($_POST['date1']) ;
//$date2 = trim($_POST['date2']) ;
}
?>
View Order Records Records